UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OrJ+Z+vZna4Awacs3S3gEmGf6YRevu7J5WejsT2+FEg='
WHERE
key_id = '7ec9c6306370ed3817dba8470ec1eeb7e163f1e630e49ab71349f8273f61a19f'
AND (
token = 'OrJ+Z+vZna4Awacs3S3gEmGf6YRevu7J5WejsT2+FEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)