UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4imxhXTgeafZASsdwQh8C1pN9FAZkVADby/6iJ2kCeo='
WHERE
key_id = '1b3c17c5f477362f70e9c2c23e9d5528823b53d590eb672c5704a007521485a9'
AND (
token = '4imxhXTgeafZASsdwQh8C1pN9FAZkVADby/6iJ2kCeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)