UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LAnQ9W9EAdsvgeeqTqj0JX4V6aBpgC9D9uty+hyFFtI='
WHERE
key_id = 'b7efc0dc8adb2b91e7ab3b1cf8fdfa3b8952f95f4e3a3f35fbd73d2024ded1f9'
AND (
token = 'LAnQ9W9EAdsvgeeqTqj0JX4V6aBpgC9D9uty+hyFFtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)