UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o+gmzruqODKCV5Uu6xD6pmi+qTTd6A4ImEt8YxLvdAo='
WHERE
key_id = 'a0e7a055dfa3361f1c85688bca2748e853b7ac65d28bae625c683245f43dd2ec'
AND (
token = 'o+gmzruqODKCV5Uu6xD6pmi+qTTd6A4ImEt8YxLvdAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)