UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oh1z20iidp2hfhUo6g5D4xmciuXYTH6wDy7NPd+o+TU='
WHERE
key_id = '4cf691758b5d366cb4bfda212d02d78b4804eef13471b6fd98cc172fc715fdc0'
AND (
token = 'oh1z20iidp2hfhUo6g5D4xmciuXYTH6wDy7NPd+o+TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)