UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B4YPMPIV04CZ3qjX/yoz442wdLS2ikPyiBr1tE+fizE='
WHERE
key_id = '7a2d3727a3d11472aeb8ac60e9bbcfb112a2ccfb90503696cc7bfe10a8dfe93c'
AND (
token = 'B4YPMPIV04CZ3qjX/yoz442wdLS2ikPyiBr1tE+fizE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)