UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1rZgHX+wq8e3JEYAXG64ePYZgBJwOsQ7VuX8VUU9OA='
WHERE
key_id = 'c79a6d165f059b618fe728a22f3014cabc0e9ab68caa6cc3ee71f6cec396c953'
AND (
token = 'X1rZgHX+wq8e3JEYAXG64ePYZgBJwOsQ7VuX8VUU9OA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)