UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1RjGkw+EAXKbklUp8NhBkCOYkX6yh0S2WTNGjRNK4cY='
WHERE
key_id = 'e47d4a40b81fe726bad82d31186d824a0aea3ba1077fa89c3babfa15cc8c0fd1'
AND (
token = '1RjGkw+EAXKbklUp8NhBkCOYkX6yh0S2WTNGjRNK4cY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)