UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCJaW73BVhUCOJX5UfRzcu4f6Ca/Frg9nxZNv9ITI6s='
WHERE
key_id = 'b4367c9155fd4dad4c3eab6768f96c945f1287c4b4d59ed8e100e8be798a46b2'
AND (
token = 'gCJaW73BVhUCOJX5UfRzcu4f6Ca/Frg9nxZNv9ITI6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)