UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nKIyelOjikdPHxIiPA+tbTaXxPraQ+SywTAFSZf4+Uw='
WHERE
key_id = 'a925f29d647ee917714da899878cc42e5e0f2ed8552b443cd11edb493f1350d1'
AND (
token = 'nKIyelOjikdPHxIiPA+tbTaXxPraQ+SywTAFSZf4+Uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)