UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7f6C/oK/b0eMSSFPDzIZPB+6YU90jWlIpRbxWgvVrbg='
WHERE
key_id = 'bcfe28a18857f6059f1b81eb4b94d65df868368f0cd2abd666bfab643ae34ae6'
AND (
token = '7f6C/oK/b0eMSSFPDzIZPB+6YU90jWlIpRbxWgvVrbg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)