UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cY7NJI+bEwllYmjZB1GVhbE4VuOeIwuprU5eNJyWq+E='
WHERE
key_id = 'ae0c3973ec274d1c4ff24cae66b4fe4be8eddc49ff32bd7a19163b63c0357784'
AND (
token = 'cY7NJI+bEwllYmjZB1GVhbE4VuOeIwuprU5eNJyWq+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)