UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X76YY+p2Ag9SBiB5FilHyWJpzzugYCNCS4340tR5ks0='
WHERE
key_id = '57de53fd8687e955e1398f1a49965cf2a55a75b07f3d1e04780ee652ef3f9bf4'
AND (
token = 'X76YY+p2Ag9SBiB5FilHyWJpzzugYCNCS4340tR5ks0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)