UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jkjRPdHHEzf9QcgPVxQu5IJgU6z0I+9NrVJXlOyn++k='
WHERE
key_id = '28539d5c9c0506387a708a513448a0ba47bfd5247ebb864cf6aca320cd4d1823'
AND (
token = 'jkjRPdHHEzf9QcgPVxQu5IJgU6z0I+9NrVJXlOyn++k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)