UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6r3rE8O9FaWDOFiEV18fVTfKOZ52Sssg+a7mQlSc5CU='
WHERE
key_id = 'efdef88588a352a0a217c6a8242d2d65d6f28af9d080f181d7b71b3a3cdef8e2'
AND (
token = '6r3rE8O9FaWDOFiEV18fVTfKOZ52Sssg+a7mQlSc5CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)