UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCmiy7RSPN/pAATJ6nWdnKsL15ZFJrRiOyIMjgOUDTo='
WHERE
key_id = 'faf4f839f2768b42324455b1aef90d18284040562e9735044ea1b50bab1366f4'
AND (
token = 'SCmiy7RSPN/pAATJ6nWdnKsL15ZFJrRiOyIMjgOUDTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)