UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4TOcdDdJbqcjw8KQqzbwrbqfMlGDrfkEgPSm2w0ibws='
WHERE
key_id = 'd42f1ca425d5598ddfe8b63c2bfac47083ff4aa80f12d1e8c43eb4487412219c'
AND (
token = '4TOcdDdJbqcjw8KQqzbwrbqfMlGDrfkEgPSm2w0ibws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)