UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0PWr435ZunCUpb6H9dELk6FGGsDz5J2khnxmZmZbb2Q='
WHERE
key_id = 'e18f83217e4fb0641eb55a04340c3fad6fbd5bae65762d0f600866c16b55d55c'
AND (
token = '0PWr435ZunCUpb6H9dELk6FGGsDz5J2khnxmZmZbb2Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)