UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1kXE5dlSMkaG4N/b0dV07gCIRJ+bA12efGvBTMj6XyE='
WHERE
key_id = '8e2d1df960587b26b0bdddf1f850918dffed3263f56f3b3d0f15f56f6d2afb1a'
AND (
token = '1kXE5dlSMkaG4N/b0dV07gCIRJ+bA12efGvBTMj6XyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)