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