UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jIUIuEaZi8hkqJYsA3cxCJkPH7KcFIP3rOFiapsnr7w='
WHERE
key_id = 'cc872654b6c93ade1cf9d19da4052213a1649be52189f1c0e010e098e9579239'
AND (
token = 'jIUIuEaZi8hkqJYsA3cxCJkPH7KcFIP3rOFiapsnr7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)