UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGFxWCSxwx8VLxbJFrQ0YSHMRKeCI1mo+fCnDe/j1qg='
WHERE
key_id = '4fd70123f74a479ae4f64b31fde636709259faf32b65286e3b1d7560dd14f8a3'
AND (
token = 'NGFxWCSxwx8VLxbJFrQ0YSHMRKeCI1mo+fCnDe/j1qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)