UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mNL5fvKc2K3w4zhZjnzYbHsrzsfbyytVZ+pa8t34usM='
WHERE
key_id = 'a2df32e3568588f8c3f912055aa15e06d1cb16d4e98a92a34db0d17b0c33bb8a'
AND (
token = 'mNL5fvKc2K3w4zhZjnzYbHsrzsfbyytVZ+pa8t34usM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)