UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5gp+dJNDOItU0wkO8O+1sTjYSliUpEPYbOp1wVxsluI='
WHERE
key_id = 'e82e72721b2497a80816497ff7f07bccfe6ea1df46b67746e54ba99f8895a153'
AND (
token = '5gp+dJNDOItU0wkO8O+1sTjYSliUpEPYbOp1wVxsluI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)