UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9zGC0xRwxs1T1NpxKmoiVxLJaTgKtzsNW80x29Gq3cM='
WHERE
key_id = '2a0ac95111bad1a049cc0e630e3afafb4e9d8eee8f875c3be9f37e43c6171cae'
AND (
token = '9zGC0xRwxs1T1NpxKmoiVxLJaTgKtzsNW80x29Gq3cM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)